<?php
$installer = $this;
$installer->startSetup();
$installer->run("
ALTER TABLE {$this->getTable('shipping_ems')} DROP KEY `dest_country`;
ALTER TABLE {$this->getTable('shipping_ems')} ADD UNIQUE `zone_id` (`website_id`, `dest_zip`, `dest_zip_to`, `condition_name`, `condition_value`, `condition_value_2`, `price`, `price_2`, `cost`, `delivery_type`, `zone_id`);
ALTER TABLE {$this->getTable('cpz_shipping_airmail')} DROP KEY `dest_country`;
ALTER TABLE {$this->getTable('cpz_shipping_airmail')} ADD UNIQUE `zone_id` (`website_id`, `dest_zip`, `dest_zip_to`, `condition_name`, `condition_value`, `condition_value_2`, `price`, `price_2`, `cost`, `delivery_type`, `zone_id`);
ALTER TABLE {$this->getTable('cpz_shipping_usps')} DROP KEY `dest_country`;
ALTER TABLE {$this->getTable('cpz_shipping_usps')} ADD UNIQUE `zone_id` (`website_id`, `dest_zip`, `dest_zip_to`, `condition_name`, `condition_value`, `condition_value_2`, `price`, `price_2`, `cost`, `delivery_type`, `zone_id`);
ALTER TABLE {$this->getTable('cpz_shipping_dhl')} DROP KEY `dest_country`;
ALTER TABLE {$this->getTable('cpz_shipping_dhl')} ADD UNIQUE `zone_id` (`website_id`, `dest_zip`, `dest_zip_to`, `condition_name`, `condition_value`, `condition_value_2`, `price`, `price_2`, `cost`, `delivery_type`, `zone_id`);
ALTER TABLE {$this->getTable('cpz_shipping_fedex')} DROP KEY `dest_country`;
ALTER TABLE {$this->getTable('cpz_shipping_fedex')} ADD UNIQUE `zone_id` (`website_id`, `dest_zip`, `dest_zip_to`, `condition_name`, `condition_value`, `condition_value_2`, `price`, `price_2`, `cost`, `delivery_type`, `zone_id`);
ALTER TABLE {$this->getTable('cpz_shipping_ups')} DROP KEY `dest_country`;
ALTER TABLE {$this->getTable('cpz_shipping_ups')} ADD UNIQUE `zone_id` (`website_id`, `dest_zip`, `dest_zip_to`, `condition_name`, `condition_value`, `condition_value_2`, `price`, `price_2`, `cost`, `delivery_type`, `zone_id`);
ALTER TABLE {$this->getTable('cpz_shipping_aramex')} DROP KEY `dest_country`;
ALTER TABLE {$this->getTable('cpz_shipping_aramex')} ADD UNIQUE `zone_id` (`website_id`, `dest_zip`, `dest_zip_to`, `condition_name`, `condition_value`, `condition_value_2`, `price`, `price_2`, `cost`, `delivery_type`, `zone_id`);
ALTER TABLE {$this->getTable('cpz_shipping_registeredairmail')} DROP KEY `dest_country`;
ALTER TABLE {$this->getTable('cpz_shipping_registeredairmail')} ADD UNIQUE `zone_id` (`website_id`, `dest_zip`, `dest_zip_to`, `condition_name`, `condition_value`, `condition_value_2`, `price`, `price_2`, `cost`, `delivery_type`, `zone_id`);
");
$installer->endSetup();


